[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount
5 items
| OrderDate.Year()Id | _SUM | Mountain | Road | Touring |
|---|---|---|---|---|
| 2024 | 1366115.42 | 572722.46 | 419115.55 | 374277.41 |
| 2023 | 5666832.16 | 2226158.93 | 2320009.82 | 1120663.41 |
| 2021 | 2289115.20 | 1128296.55 | 1160818.65 | 0.00 |
| 2022 | 5055862.93 | 2109994.17 | 2945868.76 | 0.00 |
| _SUM | 14377925.71 | 6037172.11 | 6845812.78 | 1494940.82 |
Generated 2024-05-16 20:34:23.467 UTC